/*
 Navicat Premium Data Transfer

 Source Server         : local_root
 Source Server Type    : MySQL
 Source Server Version : 80018
 Source Host           : localhost:3306
 Source Schema         : spring-cloud

 Target Server Type    : MySQL
 Target Server Version : 80018
 File Encoding         : 65001

 Date: 25/05/2020 11:34:24
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for lagou_auth_code
-- ----------------------------
DROP TABLE IF EXISTS `lagou_auth_code`;
CREATE TABLE `lagou_auth_code` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '⾃自增主键',
  `email` varchar(64) DEFAULT NULL COMMENT '邮箱地址',
  `code` varchar(6) DEFAULT NULL COMMENT '验证码',
  `createtime` datetime DEFAULT NULL COMMENT '创建时间',
  `expiretime` datetime DEFAULT NULL COMMENT '过期时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lagou_auth_code
-- ----------------------------
BEGIN;
INSERT INTO `lagou_auth_code` VALUES (1, '524259885@qq.com', 'b51g', '2020-05-24 20:58:09', '2020-05-24 21:03:09');
INSERT INTO `lagou_auth_code` VALUES (2, '524259885@qq.com', 'hg5n', '2020-05-24 21:35:14', '2020-05-24 21:40:14');
INSERT INTO `lagou_auth_code` VALUES (7, '524259885@qq.com', 'o0nm', '2020-05-24 21:54:06', '2020-05-24 21:59:06');
INSERT INTO `lagou_auth_code` VALUES (8, '524259885@qq.com', 'ety8', '2020-05-25 00:18:14', '2020-05-25 00:23:14');
INSERT INTO `lagou_auth_code` VALUES (9, '524259885@qq.com', 'po5o', '2020-05-25 01:00:07', '2020-05-25 01:05:07');
INSERT INTO `lagou_auth_code` VALUES (10, '524259885@qq.com', '7rum', '2020-05-25 01:41:19', '2020-05-25 01:46:19');
INSERT INTO `lagou_auth_code` VALUES (11, '524259885@qq.com', 'tsr2', '2020-05-25 01:55:28', '2020-05-25 02:00:28');
INSERT INTO `lagou_auth_code` VALUES (12, '524259885@qq.com', 'tobf', '2020-05-25 02:27:17', '2020-05-25 02:32:17');
COMMIT;

-- ----------------------------
-- Table structure for lagou_token
-- ----------------------------
DROP TABLE IF EXISTS `lagou_token`;
CREATE TABLE `lagou_token` (
  `id` int(11) NOT NULL AUTO_INCREMENT COMMENT '⾃自增主键',
  `email` varchar(64) NOT NULL COMMENT '邮箱地址',
  `token` varchar(255) NOT NULL COMMENT '令牌',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=13 DEFAULT CHARSET=utf8;

-- ----------------------------
-- Records of lagou_token
-- ----------------------------
BEGIN;
INSERT INTO `lagou_token` VALUES (12, '524259885@qq.com', 'c28b11e8-f7fe-4d3f-a754-95eb99c25a85');
COMMIT;

-- ----------------------------
-- Table structure for lagou_user
-- ----------------------------
DROP TABLE IF EXISTS `lagou_user`;
CREATE TABLE `lagou_user` (
  `id` int(11) NOT NULL AUTO_INCREMENT,
  `email` varchar(64) CHARACTER SET utf8 COLLATE utf8_general_ci NOT NULL COMMENT '邮箱地址',
  `name` varchar(255) DEFAULT NULL COMMENT '账户名',
  `password` varchar(255) CHARACTER SET utf8mb4 COLLATE utf8mb4_0900_ai_ci DEFAULT NULL COMMENT '密码',
  PRIMARY KEY (`id`) USING BTREE
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_0900_ai_ci;

-- ----------------------------
-- Records of lagou_user
-- ----------------------------
BEGIN;
INSERT INTO `lagou_user` VALUES (1, '524259885@qq.com', '524259885@qq.com', '123456');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
